--
-- Copyright 2023-2085 xujin <ceo@itgrail.com>
--
-- Licensed under the Grail License, Version 1.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- https://itgrail.com/docs?id=3&catalogId=87
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_all_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_all_comment`;
CREATE TABLE `t_all_comment` (
                                 `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                 `type` tinyint NOT NULL DEFAULT '0' COMMENT '评论分类 0为周期评论,1为objective评论',
                                 `okr_id` int DEFAULT NULL COMMENT '评论绑定的OKR',
                                 `period_id` int DEFAULT NULL COMMENT '评论绑定的周期的id',
                                 `okr_user_id` int DEFAULT NULL COMMENT '当前OKR绑定的用户id',
                                 `create_user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人姓名',
                                 `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                                 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                                 `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                                 `created` int DEFAULT NULL COMMENT '创建人',
                                 `updated` int DEFAULT NULL COMMENT '更新人',
                                 `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '评论内容',
                                 `object_score` int DEFAULT NULL COMMENT 'o的分数',
                                 PRIMARY KEY (`id`),
                                 KEY `idx_type` (`type`),
                                 KEY `idx_okr_id` (`okr_id`),
                                 KEY `idx_okr_user_id` (`okr_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='通用评论表';

-- ----------------------------
-- Records of t_all_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_classify
-- ----------------------------
DROP TABLE IF EXISTS `t_classify`;
CREATE TABLE `t_classify` (
                              `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                              `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类名称',
                              `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                              `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                              `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                              `created` int DEFAULT NULL COMMENT '创建人',
                              `updated` int DEFAULT NULL COMMENT '更新人',
                              PRIMARY KEY (`id`),
                              KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='okr分类表';

-- ----------------------------
-- Records of t_classify
-- ----------------------------
BEGIN;
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (1, '技改项目', '2020-09-26 15:56:45', '2020-09-26 15:56:45', 0, NULL, NULL);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (2, '安全', '2020-09-26 16:15:04', '2020-09-26 16:15:04', 0, -1, -1);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (3, '工程效率', '2020-10-16 20:26:23', '2020-10-16 20:26:23', 0, NULL, NULL);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (4, '稳定性', '2020-10-16 20:26:23', '2020-10-16 20:26:23', 0, NULL, NULL);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (5, '业务指标', '2020-10-16 20:26:23', '2020-10-16 20:26:23', 0, NULL, NULL);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (6, '需求消化', '2020-11-02 15:05:49', '2020-11-02 15:05:49', 0, NULL, NULL);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (7, '重构项目', '2020-11-02 15:05:49', '2020-11-02 15:05:49', 0, NULL, NULL);
INSERT INTO `t_classify` (`id`, `name`, `create_time`, `update_time`, `deleted`, `created`, `updated`) VALUES (12, '创新项目', '2020-11-02 15:05:49', '2020-11-02 15:05:49', 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department` (
                                `id` int unsigned NOT NULL AUTO_INCREMENT,
                                `name` varchar(256) DEFAULT NULL COMMENT '名称',
                                `identity_source` varchar(64) NOT NULL COMMENT '身份源[CREATE(create): 自建, DING_TALK(ding_talk): 钉钉, LARK(lark): 飞书, WEICHART_WORK(weichart_work): 企业微信]',
                                `identity_source_id` int DEFAULT NULL COMMENT '身份源Id',
                                `parent_id` int DEFAULT NULL COMMENT '上级部门Id',
                                `external_id` varchar(255) DEFAULT NULL COMMENT '身份源的部门唯一Id',
                                `external_parent_id` varchar(255) DEFAULT NULL COMMENT '身份源的部门父Id',
                                `dept_manager_userids` varchar(256) DEFAULT NULL,
                                `code` varchar(128) DEFAULT NULL COMMENT '编码',
                                `type` varchar(64) DEFAULT NULL COMMENT '类型[GROUP(group):集团, COMPANY(company):公司, DEPARTMENT(department):部门, UNIT(unit):单位]',
                                `path` varchar(128) DEFAULT NULL COMMENT '路径枚举ID',
                                `display_path` varchar(128) DEFAULT NULL COMMENT '路径显示名称',
                                `sequence` int DEFAULT NULL COMMENT '顺序',
                                `leaf` int DEFAULT NULL COMMENT '是否叶子节点[IS_LEAF(1): 叶子节点, NOT_LEAF(0): 非叶子节点]',
                                `enabled` int NOT NULL COMMENT '激活状态[IS_ENABLED(1):启用, NOT_ENABLED(0):未启用]',
                                `is_count` tinyint DEFAULT '0' COMMENT '是否展示部门报表, 0不展示 1展示',
                                `leader_id` int DEFAULT NULL COMMENT '部门负责人id',
                                `dept_level` int DEFAULT NULL COMMENT '部门层级',
                                `leader_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部门负责人名称',
                                `is_deleted` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '逻辑删除标志',
                                `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                `update_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                `create_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT '创建人',
                                `update_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT '更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='部门信息表';

-- ----------------------------
-- Records of t_department
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_department_user
-- ----------------------------
DROP TABLE IF EXISTS `t_department_user`;
CREATE TABLE `t_department_user` (
                                     `id` int NOT NULL AUTO_INCREMENT,
                                     `department_id` int NOT NULL COMMENT '部门Id',
                                     `user_id` int NOT NULL COMMENT '用户Id',
                                     `is_deleted` varchar(63) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '0' COMMENT '逻辑删除标志',
                                     `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                     `update_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                     `create_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT '创建人',
                                     `update_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT '更新人',
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='部门用户关系表';

-- ----------------------------
-- Records of t_department_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `t_dict_data`;
CREATE TABLE `t_dict_data` (
                               `id` int NOT NULL AUTO_INCREMENT COMMENT '数据字典详细主键',
                               `dict_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据字典分类标识',
                               `item_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据字典详细名称',
                               `item_value` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据字典详细值',
                               `item_desc` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '数据字典详细描述',
                               `item_sort` int DEFAULT NULL COMMENT '排序',
                               `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                               `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                               `status` tinyint DEFAULT '0' COMMENT 'COMMENT ''数据字典项启用状态，1：启用，0：未启用'',',
                               `item_code` varchar(200) DEFAULT NULL,
                               PRIMARY KEY (`id`),
                               KEY `idx_deleted` (`is_deleted`),
                               KEY `idx_dict_code` (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据字典详细表';

-- ----------------------------
-- Records of t_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (2, 'okrClass', '需求消化', '需求消化', '需求消化', NULL, '2020-11-02 11:56:55', '2020-11-02 11:56:55', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (3, 'okrClass', '重构项目', '重构项目', '重构项目', NULL, '2020-11-02 11:56:55', '2020-11-02 11:56:55', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (4, 'okrClass', '技改项目', '技改项目', '技改项目', NULL, '2020-11-02 11:56:56', '2020-11-02 11:56:56', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (5, 'okrClass', '稳定性', '稳定性', '稳定性', NULL, '2020-11-02 11:56:56', '2020-11-02 11:56:56', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (6, 'okrClass', '安全', '安全', '安全', NULL, '2020-11-02 11:56:56', '2020-11-02 11:56:56', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (7, 'okrClass', '工程效率', '工程效率', '工程效率', NULL, '2020-11-02 11:56:56', '2020-11-02 11:56:56', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (8, 'okrClass', '创新项目', '创新项目', '创新项目', NULL, '2020-11-02 11:56:56', '2020-11-02 11:56:56', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (9, 'okrClass', '业务指标', '业务指标', '业务指标', NULL, '2020-11-02 11:56:56', '2020-11-02 11:56:56', 0, 0, NULL);
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (19, 'period_begin', '编辑O', 'true', '编辑O', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'objectiveSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (20, 'period_begin', '编辑KR', 'true', '编辑KR', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'keyResultSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (21, 'period_begin', '权重', 'true', '权重', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'weightSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (22, 'period_begin', '进度', 'true', '进度', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'planSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (23, 'period_begin', '目标值', 'true', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'scoreSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (24, 'period_lock', '目标值', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'scoreSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (25, 'period_lock', '编辑O', 'false', '编辑O', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'objectiveSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (26, 'period_lock', '编辑KR', 'false', '编辑KR', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'keyResultSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (27, 'period_lock', '权重', 'false', '权重', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'weightSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (28, 'period_lock', '进度', 'true', '进度', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'planSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (29, 'period_comment', '进度', 'false', '进度', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'planSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (30, 'period_comment', '权重', 'false', '权重', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'weightSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (31, 'period_comment', '编辑KR', 'false', '编辑KR', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'keyResultSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (32, 'period_comment', '编辑O', 'false', '编辑O', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'objectiveSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (33, 'period_comment', '目标值', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'scoreSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (34, 'period_end', '进度', 'false', '进度', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'planSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (35, 'period_end', '权重', 'false', '权重', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'weightSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (36, 'period_end', '编辑KR', 'false', '编辑KR', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'keyResultSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (37, 'period_end', '编辑O', 'false', '编辑O', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'objectiveSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (38, 'period_end', '目标值', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'scoreSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (48, 'period_begin', '自评开关', 'true', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'mySwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (49, 'period_begin', '上级评分', 'true', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:53:50', 0, 1, 'leaderSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (50, 'period_lock', '自评开关', 'true', '进度', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'mySwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (51, 'period_lock', '上级评分', 'true', '进度', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'leaderSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (52, 'period_comment', '自评开关', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'mySwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (53, 'period_comment', '上级评分', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'leaderSwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (54, 'period_end', '自评开关', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'mySwitch');
INSERT INTO `t_dict_data` (`id`, `dict_code`, `item_name`, `item_value`, `item_desc`, `item_sort`, `gmt_create`, `gmt_modified`, `is_deleted`, `status`, `item_code`) VALUES (55, 'period_end', '上级评分', 'false', '目标值', 1, '2020-11-04 11:09:32', '2020-11-04 11:09:32', 0, 1, 'leaderSwitch');
COMMIT;

-- ----------------------------
-- Table structure for t_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `t_dict_type`;
CREATE TABLE `t_dict_type` (
                               `id` int NOT NULL AUTO_INCREMENT COMMENT '数据字典分类主键',
                               `dict_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据字典分类名称',
                               `dict_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '数据字典分类唯一标识',
                               `status` tinyint NOT NULL DEFAULT '0' COMMENT '数据字典分类启用状态，0：启用，1：未启用',
                               `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                               `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                               PRIMARY KEY (`id`),
                               KEY `idx_deleted` (`is_deleted`),
                               KEY `idx_dict_code` (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据字典分类表';

-- ----------------------------
-- Records of t_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `t_dict_type` (`id`, `dict_name`, `dict_code`, `status`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (4, 'okr分类', 'okrClass', 0, '2020-11-02 11:55:51', '2020-11-02 11:55:51', 0);
INSERT INTO `t_dict_type` (`id`, `dict_name`, `dict_code`, `status`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (5, '时间管理分类', 'time_mgmt', 1, '2020-11-03 15:53:12', '2020-11-03 15:53:21', 0);
INSERT INTO `t_dict_type` (`id`, `dict_name`, `dict_code`, `status`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (6, '录入阶段', 'period_begin', 1, '2020-11-04 11:08:57', '2020-11-04 11:08:57', 0);
INSERT INTO `t_dict_type` (`id`, `dict_name`, `dict_code`, `status`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (7, '锁定阶段', 'period_lock', 1, '2020-11-04 11:22:18', '2020-11-04 11:22:18', 0);
INSERT INTO `t_dict_type` (`id`, `dict_name`, `dict_code`, `status`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (8, '评分阶段', 'period_comment', 1, '2020-11-04 11:22:18', '2020-11-04 11:22:18', 0);
INSERT INTO `t_dict_type` (`id`, `dict_name`, `dict_code`, `status`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (9, '归档阶段', 'period_end', 1, '2020-11-04 11:22:18', '2020-11-04 11:22:18', 0);
COMMIT;


-- ----------------------------
-- Table structure for t_key_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_key_comment`;
CREATE TABLE `t_key_comment` (
                                 `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                 `key_id` int NOT NULL COMMENT 'keyId',
                                 `user_id` int DEFAULT NULL COMMENT '用户id',
                                 `user_score` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户评分',
                                 `user_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '用户评价',
                                 `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户姓名',
                                 `leader_id` int DEFAULT NULL COMMENT '领导id',
                                 `leader_score` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '领导评分',
                                 `leader_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '领导评价',
                                 `leader_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '领导姓名',
                                 `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                                 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                                 `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                                 `created` int DEFAULT NULL COMMENT '创建人',
                                 `updated` int DEFAULT NULL COMMENT '更新人',
                                 `plan_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '进度记录',
                                 PRIMARY KEY (`id`),
                                 KEY `idx_key_id` (`key_id`),
                                 KEY `idx_leader_id` (`leader_id`),
                                 KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='keyResult评论表';

-- ----------------------------
-- Records of t_key_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_key_result
-- ----------------------------
DROP TABLE IF EXISTS `t_key_result`;
CREATE TABLE `t_key_result` (
                                `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                `name` varchar(60) DEFAULT NULL COMMENT '名称',
                                `plan_rate` int DEFAULT NULL COMMENT '进度',
                                `weight_rate` int DEFAULT NULL COMMENT '权重',
                                `score_rate` varchar(20) DEFAULT NULL COMMENT '总分',
                                `objective_id` int NOT NULL COMMENT '目标id',
                                `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                                `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                                `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                                `created` int DEFAULT NULL COMMENT '创建人',
                                `updated` int DEFAULT NULL COMMENT '更新人',
                                `my_score` varchar(30) DEFAULT NULL COMMENT '自我评分',
                                `my_evaluate` text COMMENT '自我评价',
                                `leader_score` varchar(30) DEFAULT NULL COMMENT '领导评分',
                                `leader_evaluate` text COMMENT '领导评价',
                                `notify_user_list` text COMMENT '@人的信息',
                                `show_sort` int DEFAULT '0' COMMENT 'key排序字段',
                                PRIMARY KEY (`id`),
                                KEY `idx_create_time` (`create_time`),
                                KEY `idx_update_time` (`update_time`),
                                KEY `idx_objective_id` (`objective_id`),
                                KEY `idx_deleted` (`deleted`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='OKR关键成果表';

-- ----------------------------
-- Records of t_key_result
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
                          `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
                          `parent_id` bigint DEFAULT NULL COMMENT '菜单父Id',
                          `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单名称',
                          `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'url',
                          `roles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '角色',
                          `sort` int NOT NULL DEFAULT '1' COMMENT '菜单排序',
                          `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
                          `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                          `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                          `menu_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单key',
                          PRIMARY KEY (`id`),
                          KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单表';

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (1, NULL, '系统菜单', NULL, '', 1, 'el-icon-discount', '2020-09-26 18:02:13', '2023-06-13 20:15:41', 0, 'root');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (2, 1, '系统设置', '/system', 'ADMIN', 1, 'iconfont icon-xitongguanli', '1970-01-02 00:00:00', '2023-06-14 10:54:52', 0, 'system');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (3, 1, 'OKR管理', '/okrMgmt', 'USER,ADMIN', 3, 'iconfont icon-mubiao2', '2020-09-26 18:04:50', '2023-06-13 20:53:32', 1, 'okrMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (5, 1, 'OKR制定', '/myOkr', 'USER,ADMIN', 4, 'el-icon-discount', '2020-09-26 18:07:06', '2023-06-18 10:54:50', 0, 'myOkr');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (6, 1, 'OKR对齐', '/okrAlign', 'USER,ADMIN', 4, 'el-icon-discount', '2020-09-26 18:07:46', '2023-06-24 18:33:38', 0, 'orkAlign');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (7, 3, 'OKR统计', '/orkDashBoard', 'USER,ADMIN', 1, 'el-icon-discount', '2020-09-26 18:09:12', '2023-06-13 20:14:59', 1, 'okrDashBoard');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (10, 1, '数据看板', '/dashBoard', 'USER,ADMIN', 3, 'iconfont icon-Dashboard', '2020-09-28 14:46:44', '2023-06-18 10:51:26', 0, 'dashBoard');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (11, 1, '周期管理', '/okrCycleMgmt', 'ADMIN', 2, 'iconfont icon-quanshengmingzhouqiguanli', '2020-09-29 15:52:51', '2023-09-13 13:18:02', 0, 'okrCycleMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (12, 3, 'OKR明细', '/okrDetailMgmt', 'USER,ADMIN', 1, 'el-icon-discount', '2020-09-29 15:54:58', '2023-06-13 20:14:59', 1, 'okrDetailMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (13, 2, '角色管理', '/roleMgmt', 'ADMIN', 1, 'el-icon-discount', '2020-10-13 19:25:11', '2023-06-14 10:34:18', 0, 'roleMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (14, 2, '用户管理', '/userMgmt', 'ADMIN', 1, 'el-icon-discount', '2020-10-21 10:28:16', '2023-08-23 17:59:44', 0, 'userMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (15, 2, '部门管理', '/departMentMgmt', 'ADMIN', 1, 'el-icon-discount', '2020-10-21 14:09:41', '2023-08-23 17:59:46', 0, 'deptMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (17, 2, '元数据管理', '/metaDataMgmt', 'ADMIN', 1, 'el-icon-discount', '2020-10-21 14:09:41', '2023-08-23 17:59:48', 0, 'metaDataMgmt');
INSERT INTO `t_menu` (`id`, `parent_id`, `name`, `url`, `roles`, `sort`, `icon`, `gmt_create`, `gmt_modified`, `is_deleted`, `menu_key`) VALUES (22, 10, 'OKR仪表盘', '/dashBoard', 'USER,ADMIN', 1, 'el-icon-discount', '2020-11-10 14:37:00', '2023-08-23 17:59:50', 1, 'dashBoard');
COMMIT;

-- ----------------------------
-- Table structure for t_objective
-- ----------------------------
DROP TABLE IF EXISTS `t_objective`;
CREATE TABLE `t_objective` (
                               `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                               `name` varchar(200) DEFAULT NULL COMMENT '目标名称',
                               `plan_record` varchar(100) DEFAULT NULL COMMENT '进度记录',
                               `plan_rate` int DEFAULT NULL COMMENT '进度',
                               `weight_rate` int DEFAULT NULL COMMENT '权重',
                               `score_rate` varchar(20) DEFAULT NULL COMMENT '总分',
                               `okr_period_id` int NOT NULL COMMENT '周期id',
                               `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                               `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                               `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                               `created` int DEFAULT NULL COMMENT '创建人',
                               `updated` int DEFAULT NULL COMMENT '更新人',
                               `classify_id` int DEFAULT NULL,
                               `align_count` int DEFAULT '0',
                               `show_sort` int DEFAULT '0' COMMENT 'o排序字段',
                               `my_score` varchar(30) DEFAULT NULL COMMENT '自我评分',
                               `my_evaluate` text COMMENT '自我评价',
                               `leader_score` varchar(30) DEFAULT NULL COMMENT '领导评分',
                               `leader_evaluate` text COMMENT '领导评价',
                               `notify_user_list` text COMMENT '@人的信息',
                               PRIMARY KEY (`id`),
                               KEY `idx_create_time` (`create_time`),
                               KEY `idx_okr_period_id` (`okr_period_id`),
                               KEY `idx_created` (`created`),
                               KEY `idx_deleted` (`deleted`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='OKR目标表';

-- ----------------------------
-- Records of t_objective
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_okr_period
-- ----------------------------
DROP TABLE IF EXISTS `t_okr_period`;
CREATE TABLE `t_okr_period` (
                                `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                `period_length` tinyint DEFAULT NULL COMMENT '周期长度',
                                `period_type` tinyint DEFAULT '0' COMMENT '周期类型 默认为月  0月 1季度 2年',
                                `start_date` varchar(50) DEFAULT NULL COMMENT '生效日期',
                                `is_edit` tinyint DEFAULT '0',
                                `year_enable` tinyint DEFAULT '0' COMMENT '是否开启年度okr  默认0开启  1关闭',
                                `show_enable` tinyint DEFAULT '1' COMMENT '是否开启 1关闭 0启用',
                                `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                                `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                                `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                                `created` int DEFAULT NULL COMMENT '创建人',
                                `updated` int DEFAULT NULL COMMENT '更新人',
                                `my_comment_enable` tinyint DEFAULT '0',
                                `leader_comment_enable` tinyint DEFAULT '0',
                                `all_comment_enable` tinyint DEFAULT '0',
                                `name` varchar(50) DEFAULT NULL COMMENT '周期名称',
                                `start_time` date DEFAULT NULL,
                                `end_time` date DEFAULT NULL,
                                `classify_key` varchar(30) DEFAULT NULL,
                                `ext_info` text COMMENT '扩展字段',
                                PRIMARY KEY (`id`),
                                KEY `idx_create_time` (`create_time`),
                                KEY `idx_update_time` (`update_time`),
                                KEY `idx_deleted` (`deleted`),
                                KEY `idx_start_date` (`start_date`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='OKR周期表';

-- ----------------------------
-- Records of t_okr_period
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_period_control
-- ----------------------------
DROP TABLE IF EXISTS `t_period_control`;
CREATE TABLE `t_period_control` (
                                    `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                    `period_id` int NOT NULL COMMENT '周期id',
                                    `dept_id` text NOT NULL COMMENT '部门id',
                                    `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                    `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                    `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                                    PRIMARY KEY (`id`),
                                    KEY `idx_period_id` (`period_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='周期管控中间表';

-- ----------------------------
-- Records of t_period_control
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
                                `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
                                `permission` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限字符串：Shiro WildcardPermission格式',
                                `desc` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
                                `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                                `group` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限组',
                                PRIMARY KEY (`id`),
                                UNIQUE KEY `uk_permission` (`permission`),
                                KEY `idx_parent_id` (`permission`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限表';

-- ----------------------------
-- Records of t_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (1, 'ork:kr:add', '新增OKR关键成果', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, 'OKR关键成果管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (2, 'ork:kr:update', '更新OKR关键成果', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, 'OKR关键成果管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (3, 'ork:kr:delete', '删除OKR关键成果', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, 'OKR关键成果管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (4, 'ork:kr:batchUpdate', '批量更新关键成果', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, 'OKR关键成果管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (5, 'role:delete', '删除角色', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, '角色管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (6, 'role:page', '分页查询角色', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, '角色管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (7, 'role:list', '角色列表', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, '角色管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (8, 'role:queryPermByRole', '根据Role查询权限', '2020-10-13 14:22:44', '2020-10-13 14:22:44', 0, '角色管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (9, 'role:addOrUpdate', '增加或更新角色', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, '角色管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (10, 'ork:keyComment:add', '新增keyResult评论', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'keyResult评论');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (11, 'ork:allComment:add', '新增通用评论', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'keyResult评论');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (12, 'userOkrAlign:add', '新增对齐', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR对齐相关接口');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (13, 'userOkrAlign:delete', '取消对齐', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR对齐相关接口');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (14, 'userOkrAlign:findUserAlign', '查询OKR对齐树', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR对齐相关接口');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (15, 'ork:classify:add', '新增OKR分类', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'okr分类管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (16, 'ork:classify:update', '更新OKR分类', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'okr分类管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (17, 'ork:classify:list', '查询OKR分类列表', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'okr分类管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (18, 'ork:classify:detail', '查询OKR分类详情', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'okr分类管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (19, 'ork:okrPeriod:add', '新增OKR周期', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR周期管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (20, 'ork:okrPeriod:update', '更新OKR周期', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR周期管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (21, 'ork:okrPeriod:delete', '删除OKR周期', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR周期管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (22, 'ork:okrPeriod:detail', 'OKR周期详情', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR周期管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (23, 'ork:okrPeriod:getAll', '获取所有显示的OKR周期列表', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR周期管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (24, 'ork:okrPeriod:page', 'OKR周期分页', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, 'OKR周期管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (25, 'menu:upsert', '创建或更新菜单', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, '菜单管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (26, 'menu:delete', '删除菜单', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, '菜单管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (27, 'menu:queryAllMenu', '查询所有菜单', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, '菜单管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (28, 'menu:query:sub', '根据parentId查询子菜单', '2020-10-13 14:22:45', '2020-10-13 14:22:45', 0, '菜单管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (30, 'user:extensionExe', '获取用户信息走扩展', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, '用户管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (31, 'ork:objective:add', '新增OKR目标', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (32, 'ork:objective:update', '更新OKR目标', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (33, 'ork:objective:delete', '删除OKR目标', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (34, 'ork:objective:detail', '获取OKR详情', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (35, 'ork:objective:page', '获取OKR列表分页', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (36, 'ork:objective:listUserOkrs', '查询某个用户的OKR---给查询搜索框用', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (37, 'ork:objective:listUserOkrInfo', '查询指定用户的OKR---给对齐视图用', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (38, 'ork:objective:listMySameLevelOkrs', '查询当前部门人员', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (39, 'ork:objective:getUserObjectiveAlign', '根据okrId查询当前OKR对齐的所有OKR---给查询对齐视图详情使用', '2020-10-13 14:22:46', '2020-10-13 14:22:46', 0, 'OKR目标管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (40, 'user:getUserInfo', '获取用户信息', '2020-10-13 14:27:11', '2020-10-13 14:27:11', 0, '用户管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (41, 'ork:classify:page', '分类分页', '2020-10-13 17:02:33', '2020-10-13 17:02:33', 0, 'okr分类管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (42, 'metadata:dictData:add', '增加数据字典项', '2020-10-27 10:43:50', '2020-10-27 10:43:50', 0, '元数据管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (43, 'metadata:dictType:update', '删除数据字典类型', '2020-10-27 10:43:51', '2020-10-27 10:43:51', 0, '元数据管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (44, 'metadata:query', '分页查询元数据', '2020-10-27 10:43:51', '2020-10-27 10:43:51', 0, '元数据管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (45, 'metadata:dictData:delete', '删除数据字典项', '2020-10-27 10:43:51', '2020-10-27 10:43:51', 0, '元数据管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (46, 'metadata:dictType:add', '增加数据字典类型', '2020-10-27 10:43:51', '2020-10-27 10:43:51', 0, '元数据管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (47, 'metadata:dictData:update', '更新数据字典项', '2020-10-27 10:43:51', '2020-10-27 10:43:51', 0, '元数据管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (48, 'timeMgmt:location', '获取定位', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (49, 'timeMgmt:add', '添加时间管理', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (50, 'timeMgmt:detail', '获取时间管理详细', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (51, 'timeMgmt:summaryPage', '时间管理综合分页查询', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (52, 'timeMgmt:page', '时间管理详细分页查询', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (53, 'timeMgmt:chart', '时间管理填写统计表', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (54, 'timeMgmt:category', '工作事项统计表', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (55, 'timeMgmt:compare', '时间占比统计表', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (56, 'timeMgmt:categoryAverage', '工作事项平均时间分析表', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (57, 'timeMgmt:deptAverage', '部门平均时间分析表', '2020-11-09 19:59:11', '2020-11-09 19:59:11', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (58, 'timeMgmt:categoryList', '查询分类list', '2020-11-09 19:59:12', '2020-11-09 19:59:12', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (59, 'timeMgmt:mapToken', '获取高德token', '2020-11-09 19:59:12', '2020-11-09 19:59:12', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (60, 'timeMgmt:del', '删除时间管理', '2020-11-09 19:59:12', '2020-11-09 19:59:12', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (61, 'timeMgmt:deptDayAverage', '部门每日平均时间分析表', '2020-11-10 17:49:55', '2020-11-10 17:49:55', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (62, 'timeMgmt:recalculate', '综合时间管理重新计算', '2020-11-13 14:24:37', '2020-11-13 14:24:37', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (63, 'timeMgmt:userScatter', '人员时间填写情况表', '2020-11-14 17:03:17', '2020-11-14 17:03:17', 0, '时间管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (64, 'ork:allComment:delete', '删除通用评论', '2023-05-24 15:09:45', '2023-05-24 15:09:45', 0, 'keyResult评论');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (65, 'user:update', '更新用户', '2023-08-23 16:02:24', '2023-08-23 16:02:24', 0, '用户管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (66, 'user:updatePassword', '修改密码', '2023-08-23 16:02:24', '2023-08-23 16:02:24', 0, '用户管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (67, 'user:delete', '删除用户', '2023-08-23 16:02:24', '2023-08-23 16:02:24', 0, '用户管理');
INSERT INTO `t_permission` (`id`, `permission`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `group`) VALUES (68, 'user:sync', '同步用户', '2023-08-23 16:02:24', '2023-08-23 16:02:24', 0, '用户管理');
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
                          `id` int unsigned NOT NULL AUTO_INCREMENT,
                          `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色',
                          `desc` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
                          `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                          `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                          `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '角色名称',
                          PRIMARY KEY (`id`),
                          UNIQUE KEY `uk_role` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色表';

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` (`id`, `key`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `name`) VALUES (4, 'USER', '普通用户', '2019-07-04 10:10:24', '2019-07-31 10:13:15', 0, '普通用户');
INSERT INTO `t_role` (`id`, `key`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `name`) VALUES (5, 'ADMIN', '管理员用户', '2019-07-04 10:10:24', '2019-07-30 14:58:24', 0, '管理员');
INSERT INTO `t_role` (`id`, `key`, `desc`, `gmt_create`, `gmt_modified`, `is_deleted`, `name`) VALUES (8, 'BLACK', '黑名单用户，无任何权限', '2019-07-04 10:39:27', '2019-07-30 14:58:33', 0, '黑名单');
COMMIT;

-- ----------------------------
-- Table structure for t_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission` (
                                     `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
                                     `role` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色',
                                     `permission_id` int unsigned NOT NULL COMMENT '权限ID',
                                     `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                     `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                     `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                                     PRIMARY KEY (`id`),
                                     UNIQUE KEY `uk_role_permission` (`role`,`permission_id`),
                                     KEY `idx_role` (`role`),
                                     KEY `idx_permission_id` (`permission_id`),
                                     KEY `k_permission` (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色权限表';

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (187, 'USER', 10, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (188, 'USER', 11, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (189, 'USER', 1, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (190, 'USER', 2, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (191, 'USER', 3, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (192, 'USER', 4, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (193, 'USER', 15, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (194, 'USER', 16, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (195, 'USER', 17, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (196, 'USER', 18, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (197, 'USER', 41, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (198, 'USER', 23, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (199, 'USER', 12, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (200, 'USER', 13, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (201, 'USER', 14, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (202, 'USER', 31, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (203, 'USER', 32, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (204, 'USER', 33, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (205, 'USER', 34, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (206, 'USER', 35, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (207, 'USER', 36, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (208, 'USER', 37, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (209, 'USER', 38, '2020-11-14 17:09:03', '2020-11-14 17:09:03', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (210, 'USER', 39, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (211, 'USER', 48, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (212, 'USER', 49, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (213, 'USER', 50, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (214, 'USER', 51, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (215, 'USER', 52, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (216, 'USER', 53, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (217, 'USER', 54, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (218, 'USER', 55, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (219, 'USER', 56, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (220, 'USER', 57, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (221, 'USER', 58, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (222, 'USER', 59, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (223, 'USER', 60, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (224, 'USER', 61, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (225, 'USER', 62, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (226, 'USER', 63, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (227, 'USER', 30, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (228, 'USER', 40, '2020-11-14 17:09:04', '2020-11-14 17:09:04', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (229, 'ADMIN', 1, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (230, 'ADMIN', 2, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (231, 'ADMIN', 3, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (232, 'ADMIN', 4, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (233, 'ADMIN', 5, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (234, 'ADMIN', 6, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (235, 'ADMIN', 7, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (236, 'ADMIN', 8, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (237, 'ADMIN', 9, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (238, 'ADMIN', 10, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (239, 'ADMIN', 11, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (240, 'ADMIN', 12, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (241, 'ADMIN', 13, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (242, 'ADMIN', 14, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (243, 'ADMIN', 15, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (244, 'ADMIN', 16, '2023-05-10 10:35:26', '2023-05-10 10:35:26', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (245, 'ADMIN', 17, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (246, 'ADMIN', 18, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (247, 'ADMIN', 41, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (248, 'ADMIN', 19, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (249, 'ADMIN', 20, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (250, 'ADMIN', 21, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (251, 'ADMIN', 22, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (252, 'ADMIN', 23, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (253, 'ADMIN', 24, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (254, 'ADMIN', 25, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (255, 'ADMIN', 26, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (256, 'ADMIN', 27, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (257, 'ADMIN', 28, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (258, 'ADMIN', 30, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (259, 'ADMIN', 40, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (260, 'ADMIN', 31, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (261, 'ADMIN', 32, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (262, 'ADMIN', 33, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (263, 'ADMIN', 34, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (264, 'ADMIN', 35, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (265, 'ADMIN', 36, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (266, 'ADMIN', 37, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (267, 'ADMIN', 38, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (268, 'ADMIN', 39, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (269, 'ADMIN', 42, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (270, 'ADMIN', 43, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (271, 'ADMIN', 44, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (272, 'ADMIN', 45, '2023-05-10 10:35:27', '2023-05-10 10:35:27', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (273, 'ADMIN', 46, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (274, 'ADMIN', 47, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (275, 'ADMIN', 48, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (276, 'ADMIN', 49, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (277, 'ADMIN', 50, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (278, 'ADMIN', 51, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (279, 'ADMIN', 52, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (280, 'ADMIN', 53, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (281, 'ADMIN', 54, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (282, 'ADMIN', 55, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (283, 'ADMIN', 56, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (284, 'ADMIN', 57, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (285, 'ADMIN', 58, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (286, 'ADMIN', 59, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (287, 'ADMIN', 60, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (288, 'ADMIN', 61, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (289, 'ADMIN', 62, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
INSERT INTO `t_role_permission` (`id`, `role`, `permission_id`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (290, 'ADMIN', 63, '2023-05-10 10:35:28', '2023-05-10 10:35:28', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
                          `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                          `name` varchar(30) DEFAULT NULL COMMENT '姓名',
                          `user_id` int DEFAULT NULL COMMENT 'userId',
                          `account` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
                          `external_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '第三方飞书，钉钉，企业微信Id',
                          `person_code` varchar(30) DEFAULT NULL COMMENT '工号',
                          `mobile` varchar(30) DEFAULT NULL COMMENT '手机号',
                          `dept_id` varchar(30) DEFAULT NULL COMMENT '部门id',
                          `dept_name` varchar(30) DEFAULT NULL COMMENT '部门名称',
                          `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                          `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                          `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                          `created` int DEFAULT NULL COMMENT '创建人',
                          `updated` int DEFAULT NULL COMMENT '更新人',
                          `parent_dept_id` varchar(10) DEFAULT NULL,
                          `ding_url` varchar(255) DEFAULT NULL,
                          `password` varchar(280) NOT NULL,
                          `status` tinyint(1) NOT NULL DEFAULT '1',
                          `email` varchar(255) DEFAULT NULL,
                          `identity_source_id` varchar(128) DEFAULT NULL,
                          `identity_source` varchar(255) DEFAULT NULL,
                          PRIMARY KEY (`id`),
                          KEY `idx_create_time` (`create_time`),
                          KEY `idx_update_time` (`update_time`),
                          KEY `idx_ding_user_id` (`external_id`),
                          KEY `idx_person_code` (`person_code`),
                          KEY `idx_user_id` (`user_id`),
                          KEY `idx_deleted` (`deleted`),
                          KEY `t_ding_user__index_account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `name`, `user_id`, `account`, `external_id`, `person_code`, `mobile`, `dept_id`, `dept_name`, `create_time`, `update_time`, `deleted`, `created`, `updated`, `parent_dept_id`, `ding_url`, `password`, `status`, `email`, `identity_source_id`, `identity_source`) VALUES (1, 'admin', 1, 'admin', '', NULL, '18616365668', NULL, NULL, '2023-09-14 15:30:33', '2023-09-14 15:30:33', 0, NULL, NULL, NULL, '', 'UUKHSDDI5KPA43A8VL06V0TU2', 1, 'admin@itgrail.com', '1', 'ding_talk');
COMMIT;

-- ----------------------------
-- Table structure for t_user_okr_align
-- ----------------------------
DROP TABLE IF EXISTS `t_user_okr_align`;
CREATE TABLE `t_user_okr_align` (
                                    `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                    `okr_period` int NOT NULL COMMENT '周期id',
                                    `start_objective_id` int NOT NULL COMMENT '对齐人目标id',
                                    `start_user_id` int NOT NULL COMMENT '对齐人userId',
                                    `accept_objective_id` int NOT NULL COMMENT '被对齐人目标id',
                                    `accept_user_id` int NOT NULL COMMENT '被对齐人userId',
                                    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间，默认当前时间',
                                    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间，默认当前时间',
                                    `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 删除 默认是0',
                                    `created` int DEFAULT NULL COMMENT '创建人',
                                    `updated` int DEFAULT NULL COMMENT '更新人',
                                    `start_name` varchar(30) DEFAULT NULL COMMENT '对齐人姓名',
                                    PRIMARY KEY (`id`),
                                    KEY `idx_create_time` (`create_time`),
                                    KEY `idx_update_time` (`update_time`),
                                    KEY `idx_okr_period` (`okr_period`),
                                    KEY `idx_deleted` (`deleted`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='OKR对齐表';

-- ----------------------------
-- Records of t_user_okr_align
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_user_roles
-- ----------------------------
DROP TABLE IF EXISTS `t_user_roles`;
CREATE TABLE `t_user_roles` (
                                `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
                                `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                `gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                `gmt_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户角色表';

-- ----------------------------
-- Records of t_user_roles
-- ----------------------------
BEGIN;
INSERT INTO `t_user_roles` (`id`, `username`, `role`, `gmt_create`, `gmt_modified`, `is_deleted`) VALUES (1, 'admin', 'ADMIN', '2023-09-14 15:30:33', '2023-09-14 15:32:33', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

